SELECT * FROM london_stages WHERE eventid IN (20832, 20835, 20838, 20841, 20845, 20875, 20967, 20980, 21112, 21116, 21126, 21230, 21281, 21321, 21359, 21360, 21378, 21396, 21398, 21418, 21422, 21467, 21512, 21515, 21521, 21529, 21557, 21590, 21617, 21619, 21670, 21754, 21761, 21783, 21816, 21837, 22178, 22184, 22209, 22252, 22262, 22580, 22589, 22591, 22601, 22608, 22631, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22687, 22749, 22797, 22815, 22866, 22956, 22958, 22961, 22984, 22986, 23002, 23011, 23017, 23022, 23026, 23049, 23055, 23062, 23065, 23067, 23070, 23079, 23084, 23090, 23093, 23097, 23106, 23121, 23124, 23127, 23132, 23156, 23171, 23181, 23186, 23191, 23195, 23216, 23223, 23225, 23228, 23230, 23239, 23247, 23249, 23253, 23256, 23261, 23264, 23268, 23277, 23280, 23312, 23315, 23317, 23351, 23369, 23382, 23389, 23400, 23416, 23419, 23422, 23425, 23433, 23457, 23501, 23542, 23545, 23557, 23606, 23639, 23661, 23665, 23668, 23671, 23674, 23692, 23705, 23724, 23727, 23739, 23743, 23758, 23829, 23832, 23836, 23841, 23852, 23861, 23875, 23977, 23980, 23982, 23983, 23985, 23988, 23990, 24000, 24001, 24041, 24076, 24115, 24130, 24133, 24145, 24159, 24169, 24197, 24222, 24235, 24239, 24251, 24262, 24267, 24299, 24877, 24915, 24917, 24942, 24947, 24954, 24982, 24994, 25043, 25073, 25077, 25120, 25203, 25207, 25217, 25231, 25265, 25268, 25270, 25276, 25278, 25291, 25293, 25312, 25333, 25368, 25407, 25413, 25420, 25422, 25427, 25431, 25435, 25437, 25439, 25445, 25451, 25455, 25473, 25477, 25485, 25502, 25516, 25535, 25554, 25556, 25559, 25561, 25564, 25566, 25568, 25570, 25572, 25574, 25578, 25582, 25589, 25592, 25595, 25597, 25601, 25604, 25607, 25609, 25618, 25622, 25625, 25628, 25633, 25645, 25647, 25660, 25665, 25671, 25673, 25675, 25682, 25686, 25690, 25700, 25712, 25721, 25725, 25730, 25732, 25739, 25743, 25744, 25746, 25749, 25750, 25753, 25755, 25757, 25759, 25761, 25764, 25768, 25770, 25782, 25784, 25786, 25788, 25792, 25794, 25796, 25800, 25802, 25808, 25810, 25812, 25814, 25816, 25818, 25820, 25822, 25824, 25825, 25833, 25836, 25838, 25840, 25842, 25844, 25846, 25848, 25850, 25852, 25854, 25857, 25859, 25861, 25863, 25865, 25867, 25869, 25871, 25873, 25875, 25877, 25884, 25886, 25889, 25891, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 25916, 25921, 25925, 25930, 25935, 25937, 25943, 25945, 25948, 25950, 25952, 25954, 25961, 25963, 25967, 25969, 25971, 25974, 25977, 25982, 25984, 25990, 25995, 26019, 26024, 26036, 26038, 26046, 26049, 26051, 26055, 26059, 26072, 26075, 26078, 26080, 26083, 26091, 26094, 26096, 26099, 26104, 26107, 26112, 26115, 26117, 26120, 26123, 26127, 26130, 26135, 26137, 26139, 26141, 26144, 26158, 26169, 26173, 26184, 26187, 26189, 26191, 26193, 26194, 26196, 26198, 26209, 26211, 26213, 26227, 26229, 26233, 26235, 26237, 26239, 26241, 26243, 26247, 26253, 26263, 26272, 26274, 26277, 26284, 26289, 26292, 26294, 26296, 26298, 26305, 26308, 26311, 26314, 26326, 26329, 26332, 26341, 26344, 26350, 26355, 26361, 26363, 26366, 26368, 26371, 26373, 26376, 26378, 26381, 26383, 26386, 26388, 26391, 26393, 26396, 26398, 26401, 26403, 26406, 26408, 26413, 26416, 26418, 26421, 26423, 26426, 26429, 26431, 26434, 26464, 26466, 26469, 26472, 26475, 26478, 26484, 26487, 26490, 26493, 26513, 26521, 26523, 26528, 26535, 26537, 26545, 26548, 26551, 26554, 26558, 26561, 26563, 26567, 26573, 26577, 26580, 26582, 26584, 26586, 26589, 26592, 26594, 26597, 26599, 26604, 26606, 26608, 26610, 26620, 26622, 26624, 26626, 26628, 26631, 26639, 26647, 26661, 26663, 26666, 26668, 26671, 26674, 26676, 26677, 26683, 26685, 26691, 26699, 26705, 26713, 26715, 26719, 26721, 26735, 26738, 26744, 26747, 26752, 26758, 26761, 26763, 26766, 26768, 26791, 26805, 26808, 26810, 26812, 26817, 26819, 26821, 26823, 26826, 26829, 26831, 26834, 26836, 26838, 26841, 26843, 26846, 26848, 26850, 26852, 26855, 26857, 26866, 26871, 26874, 26876, 26880, 26883, 26888, 26891, 26892, 26896, 26898, 26901, 26903, 26905, 26907, 26913, 26916, 26919, 26921, 26923, 26928, 26931, 26933, 26935, 26937, 26978, 26988, 26997, 27003, 27008, 27012, 27015, 27022, 27026, 27028, 27030, 27032, 27045, 27051, 27058, 27063, 27071, 27074, 27081, 27085, 27087, 27090, 27093, 27097, 27100, 27102, 27105, 27108, 27110, 27111, 27113, 27144, 27151, 27176, 27179, 27181, 27184, 27186, 27198, 27202, 27204, 27206, 27208, 27212, 27214, 27220, 27222, 27224, 27226, 27236, 27271, 27273, 27276, 27281, 27289, 27294, 27299, 27301, 27303, 27306, 27312, 27314, 27316, 27324, 27327, 27330, 27332, 27334, 27337, 27345, 27364, 27369, 27372, 27374, 27376, 27383, 27388, 27397, 27402, 27404, 27406, 27418, 27421, 27423, 27429, 27432, 27445, 27452, 27472, 27491, 27508, 27511, 27527, 27529, 27531, 27536, 27546, 27548, 27552, 27558, 27567, 27570, 27577, 27579, 27581, 27586, 27594, 27596, 27599, 27601, 27604, 27606, 27617, 27633, 27654, 27656, 27657, 27666, 27667, 27671, 27672, 27676, 27679, 27682, 27684, 27685, 27687, 27688, 27690, 27692, 27694, 27698, 27702, 27704, 27708, 27712, 27714, 27716, 27718, 27722, 27728, 27730, 27741, 27744, 27748, 27750, 27752, 27754, 27757, 27759, 27761, 27763, 27767, 27770, 27775, 27777, 27779, 27781, 27784, 27786, 27789, 27795, 27804, 27808, 27813, 27815, 27817, 27819, 27822, 27827, 27829, 27831, 27833, 27836, 27838, 27840, 27842, 27844, 27849, 27854, 27859, 27867, 27870, 27872, 27874, 27876, 27879, 27882, 27884, 27887, 27889, 27893, 27896, 27899, 27905, 27916, 27920, 27922, 27924, 27934, 27938, 27940, 27954, 27965, 27975, 27978, 27992, 27995, 27997, 28002, 28006, 28009, 28021, 28024, 28035, 28038, 28045, 28047, 28049, 28052, 28057, 28059, 28062, 28064, 28074, 28081, 28086, 28088, 28090, 28094, 28099, 28104, 28107, 28112, 28124, 28135, 28140, 28144, 28148, 28152, 28156, 28160, 28164, 28170, 28172, 28174, 28180, 28182, 28187, 28193, 28195, 28197, 28199, 28201, 28203, 28205, 28207, 28209, 28211, 28213, 28217, 28219, 28221, 28223, 28225, 28227, 28231, 28235, 28239, 28243, 28245, 28253, 28258, 28263, 28268, 28271, 28273, 28280, 28283, 28285, 28289, 28293, 28297, 28306, 28308, 28312, 28317, 28320, 28324, 28326, 28331, 28340, 28352, 28361, 28363, 28378, 28384, 28386, 28393, 28398, 28409, 28424, 28428, 28431, 28434, 28437, 28449, 28454, 28462, 28468, 28472, 28478, 28480, 28482, 28484, 28489, 28494, 28496, 28498, 28509, 28518, 28521, 28529, 28531, 28534, 28536, 28539, 28543, 28545, 28547, 28549, 28552, 28554, 28559, 28565, 28609, 28613, 28616, 28619, 28633, 28638, 28641, 28644, 28660, 28667, 28673, 28675, 28679, 28689, 28705, 28709, 28714, 28719, 28721, 28737, 28747, 28751, 28754, 28756, 28759, 28761, 28763, 28765, 28768, 28770, 28773, 28775, 28779, 28784, 28797, 28807, 28820, 28823, 28834, 28847, 28849, 28857, 28866, 28869, 28879, 28887, 28891, 28939, 28942, 28946, 28950, 28958, 28960, 28967, 28971, 28973, 28978, 28981, 28986, 28988, 28991, 28995, 28997, 29002, 29005, 29007, 29009, 29022, 29031, 29033, 29041, 29046, 29057, 29059, 29061, 29062, 29068, 29071) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Fortune Tellers

Song: Between the acts: Beard, Lowe

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: As17411111

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: See from the Silent Grove Alexis Flies-Beard; III: A Cantata-Lowe; IV: Happy Pair-Beard

Dance: II: Les Matelotes, as17411110; Le Genereux Corsaire, as17411102

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: HHappy Pair-Beard; III: Bright Author of my Present Flame-Lowe

Dance: II: A Musette-M Mechel, Mlle Mechel; IV: A Dutch Dance-Delamain; V: A Pierrot Dance-M Mechel, Mlle Mechel

Performances

Mainpiece Title: Julius Caesar; With The Deaths Of Brutus And Cassius

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Performances

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: Bright Author of my Present Flame-Lowe; II: Happy Pair-Beard,

Dance: III: A Dutch Dance, as17411114; IV: Sailor's Dance, as17411015; V: The Swiss, as17410926

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: Happy Pair-Beard; III: Early Horn-Lowe

Dance: II: A Dutch Dance, as17411114; IV: Matelote Polonnes-Mechel

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Harlequin Shipwrecked (from Rylands MS

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: Bright Author of My Present Flame-Lowe; III: The Early Horn-Lowe

Dance: II: A Concerto-Mlle Mechel; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: Song with French Horns-Beard; IV: Song-Beard

Dance: II: A Dutch Dance, as17411114; III: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I, III: Song-Mrs Arne

Dance: II: Le Genereux Corsaire, as17420218

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsey Women Actor: Mrs Hough, Miss _Minors
Role: Colombine Actor: Miss Mann
Role: Maid Actor: Miss Story

Song: I: See from the Silent Groves-Beard; IV: Song in Italian-Beard

Dance: II: The Swiss, as17410926; III: A Miller's Dance-Delamain

Performances

Mainpiece Title: The Committee

Afterpiece Title: Chrononhotonthologos, Emperor of Queeramania

Song: I: A Ballad-Lowe; III: Bumper Squire Jones-Beard; IV: Elin@a@Roon (By Particular Desire)-Mrs Clive

Dance: II: Le Boufon, as17420325 V: The Drunken Peasant, as17411029

Performances

Mainpiece Title: The Stratagem

Cast
Role: Gipsey Actor: Miss Minors

Afterpiece Title: The King and Miller of Mansfield

Dance: II: Running Footman's Dance, as17420428 V: a Hornpipe-Phillips

Song: IV: Let me Wander not unseen-Beard

Performances

Mainpiece Title: The Rehearsal

Dance: The Mechels

Performances

Song: I: Songs-Beard

Music: III: Concerto-Veracini

Dance: II: Peasant Dance, as17420921; IV: Tyrolean Dance, as17420921

Performances

Dance: I: Grand Serious Ballet, as17421005; III: Tyrolean Dance, as17420921

Song: II: Hark the little warbling Choir-Beard

Music: IV: Concerto-Veracini

Performances

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Betty Actor: Miss Minors

Afterpiece Title: Miss Lucy in Town

Cast
Role: Mrs Tawdry Actor: Miss Bennet.

Dance: II: Les Matelotes, as17421009; V: Turkish Seraglio, as17421027

Song: III: The Early Horn-Lowe

Performances

Afterpiece Title: Miss Lucy in Town

Cast
Role: Mrs Tawdry Actor: Miss Bennet.

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Dance: As17421108

Song: Beard, Lowe

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Betty Actor: Miss Minors

Dance: Checo [Torinese], Chiaretta [Aquilanti], Brunoro, Costanza, Boromeo, Mlle Bonneval

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Betty Actor: Miss Minors

Song: III: Song-Lowe

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Stratagem

Cast
Role: Gipsey Actor: Miss Minors.

Song: II: Lowe; IV: Lowe

Music: III: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: The Stratagem

Cast
Role: Gipsey Actor: Miss Minors.

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: The Stratagem

Cast
Role: Gipsey Actor: Miss Minors.

Song: As17421204

Music: III: Concerto on Violincello-Cervetti